Desktop Computer Skills
Microsoft Office 2013: Beginning Excel
Creating Workbooks, Worksheets, and Data in Excel 2013
mo_bgel_b01_dt_enus
Excel 2013: Basic Formulas
ds_msex2013_10_enus
Excel 2013: Charts & Graphics
ds_msex2013_12_enus
Excel 2013: Conditional Formulas
ds_msex2013_16_enus
Excel 2013: Configuring Excel
ds_msex2013_18_enus
Excel 2013: Creating, Saving, & Exporting Workbooks
ds_msex2013_02_enus
Excel 2013: Custom & Conditional Formatting
ds_msex2013_06_enus
Excel 2013: Extracting Information with Formulas
ds_msex2013_17_enus
Excel 2013: Finding, Sorting, & Filtering Data
ds_msex2013_08_enus
Excel 2013: Formatting Data
ds_msex2013_05_enus
Excel 2013: Getting Started
ds_msex2013_01_enus
Excel 2013: Illustrating Documents
ds_msex2013_07_enus
Excel 2013: Manipulating Data
ds_msex2013_04_enus
Excel 2013: PivotTables & PivotCharts
ds_msex2013_13_enus
Excel 2013: Referencing Data
ds_msex2013_09_enus
Excel 2013: Sharing & Exporting Workbooks
ds_msex2013_03_enus
Excel 2013: The Power Pivot Add-in
ds_msex2013_15_enus
Excel 2013: The Power View Add-in
ds_msex2013_14_enus
Excel 2013: Working with Formulas
ds_msex2013_11_enus
Formatting Cells and Worksheets in Excel 2013
mo_bgel_b03_dt_enus
Formatting Data in Excel 2013
mo_bgel_b04_dt_enus
Performing Calculations Using Functions in Excel 2013
mo_bgel_b06_dt_enus
Presenting Data in Tables and Charts in Excel 2013
mo_bgel_b07_dt_enus
Presenting Data using Conditional Formatting and Sparklines in Excel 2013
mo_bgel_b05_dt_enus
Saving and Printing Data in Excel 2013
mo_bgel_b02_dt_enus
Creating Workbooks, Worksheets, and Data in Excel 2013
Lesson Objectives
Creating Workbooks, Worksheets, and Data in Excel 2013
- create a new workbook and open a workbook in Excel 2013
- move around Excel and enter data
- cut, copy, and paste in Excel 2013
- delete or hide a worksheet
- organize and modify worksheets in Excel 2013
Overview/Description
Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Creating Workbooks, Worksheets, and Data in Excel 2013
Lesson Objectives
Creating Workbooks, Worksheets, and Data in Excel 2013
- create a new workbook and open a workbook in Excel 2013
- move around Excel and enter data
- cut, copy, and paste in Excel 2013
- delete or hide a worksheet
- organize and modify worksheets in Excel 2013
Overview/Description
Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 allows you to create worksheets and workbooks to manage and manipulate data easily. You can cut, copy, and paste data. You can also navigate within data cells, and worksheets. Not only can you manage the data at this level, you can group, color-code, and organize the worksheets within the workbook. This course will cover creating and opening workbooks, moving around in Excel 2013, moving data, and organizing worksheets. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Excel 2013: Basic Formulas
Lesson Objectives
Excel 2013: Basic Formulas
- Inserting a formula using the function library
- Performing simple calculations with formulas
- Using automated formulas in a table
- Creating automated cumulative totals
- Inserting subtotals
- Counting cells in a range
- Ranking a value
- Rounding a number
- Using replacement formulas
- Converting number types
- Factorizing the results of a division
- Creating random values
Overview/Description
Get the most out of Excel 2013 by learning about formulas, functions, and totals. Explore using the function library, using automated formulas, inserting subtotals, ranking values, converting number types, and creating random values.
Get the most out of Excel 2013 by learning about formulas, functions, and totals. Explore using the function library, using automated formulas, inserting subtotals, ranking values, converting number types, and creating random values.
Target
Prerequisites: none
Excel 2013: Charts & Graphics
Lesson Objectives
Excel 2013: Charts & Graphics
- Inserting a chart
- Labeling a chart
- Formatting a chart
- Customizing your chart axes
- Creating a chart template
- Presenting negative values in your chart
- Creating a pie chart
- Creating a scatter chart
- Creating a bubble chart
- Creating a radar chart
- Combining two types of chart
- Creating a comparative chart using symbols
- Inserting trendlines
- Customizing your trendlines
Overview/Description
Display your data visually using Excel's built-in charting features. Learn how to insert, label, and format a chart; create various types of charts; combine types of charts; create comparative charts; and insert and customize trendlines.
Target
Prerequisites: none
Excel 2013: Conditional Formulas
Lesson Objectives
Excel 2013: Conditional Formulas
- Inserting a conditional sum formula
- Inserting a conditional message formula
- Performing complex conditional formulas
- Creating multiple conditions
- Using IF & OR in conditional formulas
- Using conditional formulas to count up value occurrences
- Keeping your table up to date with conditional formulas
- Translating data in your worksheet
- Using reference positions in conditional formulas
Overview/Description
Conditional formulas let you perform a calculation on a range of values by specifying the criteria the data must meet. Discover how to use built-in conditional formulas and create your own.
Target
Prerequisites: none
Excel 2013: Configuring Excel
Lesson Objectives
Excel 2013: Configuring Excel
- Adjusting your input options
- Customizing your document view settings
- Customizing your interface
- Customizing the Quick Access toolbar
- Customizing the Quick Access toolbar
Overview/Description
Excel can be customized to suit the user's preferences and work habits. Discover how you can adjust the input options, document view settings, interface, ribbon, and Quick Access Toolbar.
Target
Prerequisites: none
Excel 2013: Creating, Saving, & Exporting Workbooks
Lesson Objectives
Excel 2013: Creating, Saving, & Exporting Workbooks
- Creating & opening a document
- Using document templates
- Managing your worksheets
- Saving your document
- Saving your document as a PDF
- Returning to a previous version of your document
- Inserting headers & footers
- Adjusting your print page layout
- Adjusting your print options
- Printing your document
- Checking for compatibility issues
- Editing your document properties
- Checking for personal information in your document
- Creating an accessible document
- Protecting your document
Overview/Description
Learn the basics of working with Excel 2013, including creating workbooks, using templates, saving, adding headers and footers, adjusting print options and printing, editing workbook properties, and protecting a workbook.
Learn the basics of working with Excel 2013, including creating workbooks, using templates, saving, adding headers and footers, adjusting print options and printing, editing workbook properties, and protecting a workbook.
Target
Prerequisites: none
Excel 2013: Custom & Conditional Formatting
Lesson Objectives
Excel 2013: Custom & Conditional Formatting
- Customizing your number formats
- Customizing your text formats
- Customizing the date & time formats
- Creating conditional custom formats
- Using conditional formatting tools
- Applying color to the first new entry in a list
Overview/Description
Excel 2013 is highly customizable when it comes to formats. Learn how to customize number, text, and date and time formats; create conditional formats; use conditional formatting tools; and apply color to the first new entry in a list.
Target
Prerequisites: none
Excel 2013: Extracting Information with Formulas
Lesson Objectives
Excel 2013: Extracting Information with Formulas
- Retrieving information with dates
- Finding a date automatically
- Finding the largest & smallest values in a list
- Separating data into multiple cells
- Combining data values in a single cell
- Retrieving information on a cell
- Retrieving information on your text
- Cross referencing two data lists
- Inserting data automatically
- Finding a value in a double entry table
- Performing a search across two tables
- Finding data in a database
- Performing calculations using your database
Overview/Description
You can use formulas to extract and analyze data in your spreadsheet. Discover how to use the MAX, MIN, LARGE, and SMALL formulas, and work with VLOOKUP to cross-reference the contents of two lists.
Target
Prerequisites: none
Excel 2013: Finding, Sorting, & Filtering Data
Lesson Objectives
Excel 2013: Finding, Sorting, & Filtering Data
- Using the Find & Replace tools
- Using the Find & Replace tools in a formula
- Sorting your data
- Filtering your data
- Sorting & filtering using colors
- Using the advanced filter options
- Hiding duplicate values
- Freezing & unfreezing panes
- Grouping items & creating an outline
Overview/Description
You can easily find specific data and format how data displays in Excel 2013. Learn how to use the Find and Replace tools, sort and filter data, and hide duplicate values. Explore freezing panes, grouping items, and creating an outline.
You can easily find specific data and format how data displays in Excel 2013. Learn how to use the Find and Replace tools, sort and filter data, and hide duplicate values. Explore freezing panes, grouping items, and creating an outline.
Target
Prerequisites: none
Excel 2013: Formatting Data
Lesson Objectives
Excel 2013: Formatting Data
- Setting your data type
- Formatting your data
- Aligning your data
- Using colors
- Changing your cell style
- Using document themes
- Using formulas to modify your text case
- Creating a title
- Creating a table
- Resizing columns & rows
- Inserting columns & rows in a table
- Inserting borders
- Transferring format styles
Overview/Description
Excel 2013 provides numerous features that allow you to display data in a visually appealing way. Learn how to format and align data, use colors and themes, create titles and tables, resize and insert columns and rows, and add borders.
Target
Prerequisites: none
Excel 2013: Getting Started
Lesson Objectives
Excel 2013: Getting Started
- Using Excel 2013
- Using the zoom function
- Using the view modes
- Moving between documents
Overview/Description
Before starting to work in Excel 2013, it's important to learn about the interface and its features. Explore the interface, and learn about the zoom function, view modes, and how to move between workbooks.
Target
Prerequisites: none
Excel 2013: Illustrating Documents
Lesson Objectives
Excel 2013: Illustrating Documents
- Inserting an image
- Inserting a screenshot
- Editing an image
- Inserting a hyperlink
Overview/Description
Excel 2013 includes some built-in features for working with images and allows you to link inside and outside of a workbook. Learn how to insert images and screenshots into a workbook, edit an image, and insert a hyperlink.
Excel 2013 includes some built-in features for working with images and allows you to link inside and outside of a workbook. Learn how to insert images and screenshots into a workbook, edit an image, and insert a hyperlink.
Target
Prerequisites: none
Excel 2013: Manipulating Data
Lesson Objectives
Excel 2013: Manipulating Data
- Selecting cells
- Inputting data
- Inserting special characters
- Editing multiple worksheets simultaneously
- Deleting items in your spreadsheet
- Undoing & redoing actions
- Creating automatic data series
- Using the Flash Fill feature
- Inserting dropdown menus
- Using the spell check tool
- Transferring data
- Copying & pasting data
- Moving data from one worksheet to another
- Transposing a data range
- Consolidating your data
Overview/Description
Learn the basics of working with data in Excel 2013, including selecting cells, inputting data, undoing and redoing actions, filling, spellchecking, copy and pasting, moving data to another worksheet, and consolidating data.
Learn the basics of working with data in Excel 2013, including selecting cells, inputting data, undoing and redoing actions, filling, spellchecking, copy and pasting, moving data to another worksheet, and consolidating data.
Target
Prerequisites: none
Excel 2013: PivotTables & PivotCharts
Lesson Objectives
Excel 2013: PivotTables & PivotCharts
- Creating a PivotTable
- Creating a PivotTable with multiple data tables
- Editing your PivotTable
- Formatting your PivotTable
- Copying & reusing your PivotTable
- Inserting a calculation in your PivotTable
- Sorting & filtering data in your PivotTable
- Grouping data in your PivotTable
- Inserting a slicer in your PivotTable
- Customizing your slicer
- Comparing values in a PivotTable
- Inserting a PivotChart
- Modifying your PivotChart
- Analyzing your database tables in a PivotChart
Overview/Description
Analyze data efficiently using Excel 2013. Discover how to work with PivotTables, including formatting, sorting, filtering, grouping, and using slicers. In addition, explore how to insert, modify, and analyze using PivotCharts.
Target
Prerequisites: none
Excel 2013: Referencing Data
Lesson Objectives
Excel 2013: Referencing Data
- Referencing your cells
- Using data across multiple worksheets
- Choosing between absolute & relative cell references
- Naming your data ranges
- Performing calculations using constant values
- Using cell references indirectly
- Keeping an eye on your data
- Activating automatic updates
- Using formula auditing
- Understanding formula errors
Overview/Description
Increase your Excel 2013 mastery by learning about referencing cells, using data across worksheets, absolute and relative references, and named ranges. In addition, explore automatic updates, formula auditing, and formula errors.
Target
Prerequisites: none
Excel 2013: Sharing & Exporting Workbooks
Lesson Objectives
Excel 2013: Sharing & Exporting Workbooks
- Sending your document via email
- Publishing your spreadsheet online
- Sharing your document via OneDrive
- Sharing your document via Office 365
- Commenting on a document
- Tracking changes in a document
Overview/Description
Easily share spreadsheets with colleagues using Excel 2013 collaboration features. Discover how to share workbooks via email, OneDrive, and Office 365; publish workbooks online, and use comments and track changes.
Target
Prerequisites: none
Excel 2013: The Power Pivot Add-in
Lesson Objectives
Excel 2013: The Power Pivot Add-in
- Activating Power Pivot
- Importing your database
- Creating Power Pivot relationships
- Formatting your Power Pivot tables
- Applying data formats in Power Pivot tables
- Sorting the data in your Power Pivot table
- Filtering data in your Power Pivot table
- Creating a calculated field in your Power Pivot table
- Creating custom views in your Power Pivot table
- Updating your Power Pivot tables
- Creating an advanced PivotTable
- Creating an advanced PivotChart
- Creating a dashboard
Overview/Description
Power Pivot allows you to create advanced PivotTables and PivotCharts in Excel 2013. Discover how to work with Power Pivot, so you can analyze data from a variety of sources.
Target
Prerequisites: none
Excel 2013: The Power View Add-in
Lesson Objectives
Excel 2013: The Power View Add-in
- Activating Power View
- Creating a new report
- Managing your report tables
- Grouping data with tiles
- Creating relationships between tables
- Formatting your Power View report
- Filtering the data in your report
- Reusing a table
- Using a Matrix Table to visualize your data
- Using bar & column charts to visualize your data
- Using line charts to visualize your data
- Using scatter charts to visualize your data
- Using pie charts to visualize your data
- Visualizing your data in map form
Overview/Description
Power View allows you to create reports you can use to extract, analyze, and present data contained in the different tables in your workbook. Learn how to use Power View, including creating and formatting reports and creating relationships.
Power View allows you to create reports you can use to extract, analyze, and present data contained in the different tables in your workbook. Learn how to use Power View, including creating and formatting reports and creating relationships.
Target
Prerequisites: none
Excel 2013: Working with Formulas
Lesson Objectives
Excel 2013: Working with Formulas
- Calculating the interest on a loan
- Simulating a loan
- Reaching a target value
- Solving a problem
- Creating automatic reports
- Finding identical values in your spreadsheet
- Finding duplicates in your document
- Visualizing your duplicate values
- Preventing duplicate values
Overview/Description
Learn how to use Excel 2013 for common tasks like calculating the interest on a loan, reaching a target value, solving problems, creating automatic reports, as well as finding, visualizing, and preventing duplicate values.
Target
Prerequisites: none
Formatting Cells and Worksheets in Excel 2013
Lesson Objectives
Formatting Cells and Worksheets in Excel 2013
- change font formatting in Excel 2013
- apply borders and fills and create a cell style
- copy formatting with Format Painter in Excel 2013
- change the alignment, indentation, and orientation of data in Excel 2013
- merge cells and wrap text in Excel 2013
Overview/Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores formatting cells and text, using tools such as the Format Painter. It shows how to change the way text is presented to make it more visually appealing, including formatting fonts, and applying borders and fills. This course also covers aligning and orienting data, and merging and splitting cells. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores formatting cells and text, using tools such as the Format Painter. It shows how to change the way text is presented to make it more visually appealing, including formatting fonts, and applying borders and fills. This course also covers aligning and orienting data, and merging and splitting cells. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Formatting Cells and Worksheets in Excel 2013
Lesson Objectives
Formatting Cells and Worksheets in Excel 2013
- change font formatting in Excel 2013
- apply borders and fills and create a cell style
- copy formatting with Format Painter in Excel 2013
- change the alignment, indentation, and orientation of data in Excel 2013
- merge cells and wrap text in Excel 2013
Overview/Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores formatting cells and text, using tools such as the Format Painter. It shows how to change the way text is presented to make it more visually appealing, including formatting fonts, and applying borders and fills. This course also covers aligning and orienting data, and merging and splitting cells. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of worksheets and workbooks. Data and cells can be manipulated and customized using various positioning and formatting features. This course explores formatting cells and text, using tools such as the Format Painter. It shows how to change the way text is presented to make it more visually appealing, including formatting fonts, and applying borders and fills. This course also covers aligning and orienting data, and merging and splitting cells. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Formatting Data in Excel 2013
Lesson Objectives
Formatting Data in Excel 2013
- format numbers in Excel 2013
- use Auto Fill to copy and fill a series in Excel 2013
- extract or add data using Flash Fill in Excel 2013
- create and modify a hyperlink in an Excel 2013 workbook
Overview/Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of data, automatically fill data, and create hyperlinks to various places. This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a web site, another place in the workbook, a new document, and e-mail. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of data, automatically fill data, and create hyperlinks to various places. This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a web site, another place in the workbook, a new document, and e-mail. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Formatting Data in Excel 2013
Lesson Objectives
Formatting Data in Excel 2013
- format numbers in Excel 2013
- use Auto Fill to copy and fill a series in Excel 2013
- extract or add data using Flash Fill in Excel 2013
- create and modify a hyperlink in an Excel 2013 workbook
Overview/Description
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of data, automatically fill data, and create hyperlinks to various places. This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a web site, another place in the workbook, a new document, and e-mail. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 provides a number of tools and features that allow you to visually enhance the appearance of data, automatically fill data, and create hyperlinks to various places. This course covers formatting numbers in currency, date, and percentage formats. It also covers ways of automatically filling data through Auto Fill and Flash Fill. Finally, this course covers creating hyperlinks to a web site, another place in the workbook, a new document, and e-mail. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Performing Calculations Using Functions in Excel 2013
Lesson Objectives
Performing Calculations Using Functions in Excel 2013
- create a basic formula in Excel 2013
- reference cells in formulas in Excel 2013
- create a named range in Excel 2013
- use basic functions in Excel 2013
- create formulas using basic logical functions in Excel 2013
- create an IF-type formula in Excel 2013
Overview/Description
Excel 2013 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Performing Calculations Using Functions in Excel 2013
Lesson Objectives
Performing Calculations Using Functions in Excel 2013
- create a basic formula in Excel 2013
- reference cells in formulas in Excel 2013
- create a named range in Excel 2013
- use basic functions in Excel 2013
- create formulas using basic logical functions in Excel 2013
- create an IF-type formula in Excel 2013
Overview/Description
Excel 2013 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 provides you with the tools that allow you to perform calculations on your workbook data. Being able to use formulas to do complicated calculations not only simplifies your work but also helps to reduce the number of errors that can arise in such complex tasks. This course introduces the basic concepts and terminology associated with formulas and functions. It also covers various ways of referring to cells and cell ranges and demonstrates how to use basic functions including logical and IF-type functions. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Presenting Data in Tables and Charts in Excel 2013
Lesson Objectives
Presenting Data in Tables and Charts in Excel 2013
- create a table in Excel 2013
- format a table and customize a table style in Excel 2013
- create a chart in Excel 2013
- add elements to a chart in Excel 2013
- change the appearance of a chart in Excel 2013
Overview/Description
Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization of your data. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization of your data. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Presenting Data in Tables and Charts in Excel 2013
Lesson Objectives
Presenting Data in Tables and Charts in Excel 2013
- create a table in Excel 2013
- format a table and customize a table style in Excel 2013
- create a chart in Excel 2013
- add elements to a chart in Excel 2013
- change the appearance of a chart in Excel 2013
Overview/Description
Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization of your data. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Using the tables and charts features in Excel 2013, you can create attractive and well-organized representations of worksheet and workbook data. Both tables and charts can be easily inserted and customized. This course demonstrates how to effectively use and customize tables and charts in Excel 2013; it explores available table styles and chart types and the best use of each type. And the course shows how to change the different elements of a table or chart to provide an effective visualization of your data. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Presenting Data using Conditional Formatting and Sparklines in Excel 2013
Lesson Objectives
Presenting Data using Conditional Formatting and Sparklines in Excel 2013
- apply conditional formatting to a worksheet in Excel 2013
- create custom conditional formatting rules in Excel 2013
- create a basic sparkline in Excel 2013
- create an advanced sparkline in Excel 2013
Overview/Description
Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Presenting Data using Conditional Formatting and Sparklines in Excel 2013
Lesson Objectives
Presenting Data using Conditional Formatting and Sparklines in Excel 2013
- apply conditional formatting to a worksheet in Excel 2013
- create custom conditional formatting rules in Excel 2013
- create a basic sparkline in Excel 2013
- create an advanced sparkline in Excel 2013
Overview/Description
Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Excel 2013 provides tools that enable you to efficiently present your data and that can also make your data easier to understand. Conditional formatting allows you to highlight trends and exceptions in cells or ranges of cells by presenting the identified data in a number of unique ways to make it stand out. Sparklines are small charts within a cell that provide a visual representation of data and can be used to show trends in an appealing manner. This course covers applying conditional formatting, creating custom rules, and creating basic and advanced sparklines. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013.
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Saving and Printing Data in Excel 2013
Lesson Objectives
Saving and Printing Data in Excel 2013
- save a workbook in Excel 2013
- change the default save options in Excel 2013
- recover a workbook in Excel 2013
- print a workbook
- configure the page layout in Excel 2013
Overview/Description
Excel 2013 makes it easy to save and print workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it as a hard copy or share with someone else. You can save in various formats since Excel 2013 supports many file types. This course covers saving data, and preparing for printing including setting print options, page setup, print titles, headers and footers, and row and column headings. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013
Excel 2013 makes it easy to save and print workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it as a hard copy or share with someone else. You can save in various formats since Excel 2013 supports many file types. This course covers saving data, and preparing for printing including setting print options, page setup, print titles, headers and footers, and row and column headings. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Saving and Printing Data in Excel 2013
Lesson Objectives
Saving and Printing Data in Excel 2013
- save a workbook in Excel 2013
- change the default save options in Excel 2013
- recover a workbook in Excel 2013
- print a workbook
- configure the page layout in Excel 2013
Overview/Description
Excel 2013 makes it easy to save and print workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it as a hard copy or share with someone else. You can save in various formats since Excel 2013 supports many file types. This course covers saving data, and preparing for printing including setting print options, page setup, print titles, headers and footers, and row and column headings. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013
Excel 2013 makes it easy to save and print workbooks and worksheets. When you create an Excel workbook, you will most likely want to save it, and in many instances, print it as a hard copy or share with someone else. You can save in various formats since Excel 2013 supports many file types. This course covers saving data, and preparing for printing including setting print options, page setup, print titles, headers and footers, and row and column headings. This course will help prepare learners for the Microsoft Certification Exam 77-420: Excel 2013 which certifies individuals as Microsoft Office Specialist (MOS): Excel 2013
Target Audience
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
Personnel at all levels of the enterprise; end-users seeking to attain competency in Microsoft Excel 2013; end-users seeking to obtain Microsoft Office Specialist (MOS) certification at Core level in the use of Microsoft Excel 2013; end-users seeking a basic IT certification
